--------------------------------------------------------
--  File created - Friday-November-13-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table DIR_LIST
--------------------------------------------------------
 
--------------------------------------------------------
--  DDL for Table TB_APP_ERROR
--------------------------------------------------------

  CREATE TABLE "TB_APP_ERROR" 
   (	"NAME" nvarchar(500), 
	"MSG" nvarchar(4000), 
	"LINE" nvarchar(4000), 
	"CDATE" nvarchar(10), 
	"CTIME" DATE, 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_AC_INSTALLER_INF
--------------------------------------------------------

  CREATE TABLE "TB_CM_AC_INSTALLER_INF" 
   (	"INST_CODE" nvarchar(10), 
	"INST_NAME" nvarchar(100), 
	"BILLTO_CODE" nvarchar(50), 
	"PRV_CODE" nvarchar(5), 
	"DIST_CODE" nvarchar(5), 
	"CELL#" nvarchar(20), 
	"SMS_CELL#" nvarchar(20), 
	"EMAIL_ADD" nvarchar(30), 
	"USE_FLAG" nvarchar(1) DEFAULT 'Y', 
	"CREATE_DATE" DATE, 
	"GENDER" nvarchar(10), 
	"DOB" DATE, 
	"EXPERIENCE" nvarchar(4000), 
	"CREATE_USER" nvarchar(20), 
	"UPDATE_DATE" DATE, 
	"REGION" nvarchar(2), 
	"CONTACTOR_NAME" nvarchar(100), 
	"SMS_YN" nvarchar(1) DEFAULT 'N'
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_BILLTO_INF
--------------------------------------------------------

  CREATE TABLE "TB_CM_BILLTO_INF" 
   (	"BILLTO_CODE" nvarchar(50), 
	"PROFILE" nvarchar(50), 
	"SHORT_NAME" nvarchar(200), 
	"FULL_NAME" nvarchar(500), 
	"REPRESENTATIVE" nvarchar(200), 
	"BIZ_NO" nvarchar(50), 
	"TAX_ID" nvarchar(100), 
	"CUSTOMER_CODE" nvarchar(50), 
	"ADDRESS" nvarchar(1000), 
	"CREDIT_LEVEL" nvarchar(50), 
	"GRADE" nvarchar(50), 
	"HIGH_SALE_CHANNEL" nvarchar(200), 
	"PAY_FROM" nvarchar(50), 
	"LOW_PRICE_GROUP" nvarchar(200), 
	"HIGH_PRICE_GROUP" nvarchar(200), 
	"VN_DEPARTMENT" nvarchar(100), 
	"AVTIVE" nvarchar(50), 
	"LOW_SALE_CHANNEL" nvarchar(200), 
	"BUYING_GROUP" nvarchar(200), 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_DISTRICT
--------------------------------------------------------

  CREATE TABLE "TB_CM_DISTRICT" 
   (	"ID" NUMERIC(10,0), 
	"PROVINCE_ID" NUMERIC(10,0), 
	"NAME" nvarchar(50), 
	"LNG"NUMERIC, 
	"LAT"NUMERIC, 
	"ENTRY_USER_ID" NUMERIC(10,0), 
	"ENTRY_USER_NAME" nvarchar(50), 
	"ENTRY_DATE_TIME" DATE, 
	"UPDATE_USER_ID" NUMERIC(10,0), 
	"UPDATE_USER_NAME" nvarchar(50), 
	"UPDATE_DATE_TIME" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_INCENTIVE_ADHOC
--------------------------------------------------------

  CREATE TABLE "TB_CM_INCENTIVE_ADHOC" 
   (	"SCHEME_ID" nvarchar(12), 
	"SCHEME_NAME" nvarchar(100), 
	"START_DATE" DATE, 
	"END_DATE" DATE, 
	"PURPOSE" nvarchar(1000), 
	"CREATE_DATE" DATE, 
	"CREATE_USER" nvarchar(10), 
	"UPDATE_DATE" DATE, 
	"REGION" nvarchar(2) DEFAULT 00, 
	"CLOSE_FLAG" nvarchar(2) DEFAULT 'N', 
	"CLOSE_USER" nvarchar(10), 
	"CLOSE_DATE" DATE, 
	"MDI" nvarchar(1) DEFAULT 'T', 
	"PURPOSE_TYPE" nvarchar(1), 
	"BILLTO_CODE" nvarchar(100), 
	"BILLTO_YN" nvarchar(1) DEFAULT 'N'
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_INCENTIVE_ADHOC_DETAIL
--------------------------------------------------------

  CREATE TABLE "TB_CM_INCENTIVE_ADHOC_DETAIL" 
   (	"SCHEME_ID" nvarchar(12), 
	"BILLTO_CODE" nvarchar(20), 
	"MODEL" nvarchar(30), 
	"UNIT" nvarchar(2) DEFAULT 1, 
	"POINT" nvarchar(12), 
	"AMT" nvarchar(12), 
	"CREATE_DATE" DATE, 
	"CREATE_USER" nvarchar(10), 
	"REGION" nvarchar(2) DEFAULT 00
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_INCENTIVE_BALANCE
--------------------------------------------------------

  CREATE TABLE "TB_CM_INCENTIVE_BALANCE" 
   (	"YYYYMM" nvarchar(6), 
	"SCHEME_ID" nvarchar(12), 
	"SHOP_CODE" nvarchar(8), 
	"MODEL" nvarchar(20), 
	"POINT" nvarchar(10) DEFAULT 0, 
	"AMT" nvarchar(10) DEFAULT 0, 
	"CLOSED_FLAG" nvarchar(1) DEFAULT 'N', 
	"CREATE_DATE" DATE, 
	"UPDATE_DATE" DATE, 
	"REGION_ID" nvarchar(2), 
	"CLOSED_USER" nvarchar(10), 
	"CLOSED_DATE" DATE, 
	"QTY" nvarchar(5) DEFAULT 0, 
	"BILLTO_CODE" nvarchar(50), 
	"BILLTO_NAME" nvarchar(500)
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_INCENTIVE_CLOSE_MST
--------------------------------------------------------

  CREATE TABLE "TB_CM_INCENTIVE_CLOSE_MST" 
   (	"CLOSE_PERIOD" nvarchar(6), 
	"START_DATE" nvarchar(8), 
	"END_DATE" nvarchar(8), 
	"CREATE_DATE" DATE, 
	"CLOSE_FLAG" nvarchar(1) DEFAULT 'N', 
	"CREATE_USER" nvarchar(8), 
	"CLOSE_USER" nvarchar(8), 
	"CLOSE_DATE" DATE, 
	"SCHEME_ID" nvarchar(12), 
	"PURPOSE" nvarchar(200)
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_INCENTIVE_DETAIL
--------------------------------------------------------

  CREATE TABLE "TB_CM_INCENTIVE_DETAIL" 
   (	"SCHEME_ID" nvarchar(12), 
	"MODEL" nvarchar(30), 
	"UNIT" nvarchar(2) DEFAULT 1, 
	"POINT" nvarchar(12), 
	"AMT" nvarchar(12), 
	"CREATE_DATE" DATE, 
	"CREATE_USER" nvarchar(10), 
	"REGION" nvarchar(2) DEFAULT 00, 
	"UPDATE_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_INCENTIVE_MST
--------------------------------------------------------

  CREATE TABLE "TB_CM_INCENTIVE_MST" 
   (	"SCHEME_ID" nvarchar(12), 
	"SCHEME_NAME" nvarchar(100), 
	"START_DATE" DATE, 
	"END_DATE" DATE, 
	"PURPOSE" nvarchar(1000), 
	"CREATE_DATE" DATE, 
	"CREATE_USER" nvarchar(10), 
	"UPDATE_DATE" DATE, 
	"REGION" nvarchar(2) DEFAULT 00, 
	"CLOSE_FLAG" nvarchar(2) DEFAULT 'N', 
	"CLOSE_USER" nvarchar(10), 
	"CLOSE_DATE" DATE, 
	"MDI" nvarchar(1) DEFAULT 'T'
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_MODEL_CAT
--------------------------------------------------------

  CREATE TABLE "TB_CM_MODEL_CAT" 
   (	"PROD_L1" nvarchar(5), 
	"MODEL" nvarchar(25), 
	"CREATE_DATE" DATE, 
	"SUFFIX" nvarchar(20), 
	"MP_MODEL" nvarchar(25), 
	"MP_SUFFIX" nvarchar(20), 
	"ACTIVE_CODE" nvarchar(1), 
	"SALE_FLAG" nvarchar(1), 
	"PROD_L2" nvarchar(4), 
	"PROD_L3" nvarchar(8), 
	"PROD_L4" nvarchar(10), 
	"TENTATIVE_FLAG" nvarchar(1), 
	"MODEL_SPEC" nvarchar(200), 
	"PUR_TYPE" nvarchar(1), 
	"ENABLE_FLAG" nvarchar(1), 
	"LAST_UPDATE_DATE" DATE, 
	"UNIT" nvarchar(1), 
	"AU_CODE" nvarchar(10), 
	"AF_CODE" nvarchar(4), 
	"EOM" nvarchar(2), 
	"PROD_TYPE" nvarchar(5), 
	"MKT" nvarchar(1), 
	"IF_DATE" DATE, 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_MRP
--------------------------------------------------------

  CREATE TABLE "TB_CM_MRP" 
   (	"MODEL" nvarchar(50), 
	"MRP" nvarchar(15), 
	"CREATE_DATE" DATE, 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_ORGANIZATION
--------------------------------------------------------

  CREATE TABLE "TB_CM_ORGANIZATION" 
   (	"ORG_CODE" nvarchar(3), 
	"ORG_NAME" nvarchar(50), 
	"DESCRIPTION" nvarchar(100)
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_PROVINCE
--------------------------------------------------------

  CREATE TABLE "TB_CM_PROVINCE" 
   (	"ID" NUMERIC(10,0), 
	"REGION_ID" nvarchar(2), 
	"NAME" nvarchar(50), 
	"LNG"NUMERIC, 
	"LAT"NUMERIC, 
	"ENTRY_USER_ID" NUMERIC(10,0), 
	"ENTRY_USER_NAME" nvarchar(50), 
	"ENTRY_DATE_TIME" DATE, 
	"UPDATE_USER_ID" NUMERIC(10,0), 
	"UPDATE_USER_NAME" nvarchar(50), 
	"UPDATE_DATE_TIME" DATE, 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_REGION
--------------------------------------------------------

  CREATE TABLE "TB_CM_REGION" 
   (	"ID" nvarchar(2), 
	"NAME" nvarchar(50), 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_SHIPTO_INF
--------------------------------------------------------

  CREATE TABLE "TB_CM_SHIPTO_INF" 
   (	"BILLTO_CODE" nvarchar(30), 
	"BILLTO_NAME" nvarchar(150), 
	"BILLTO_FULLNAME" nvarchar(200), 
	"BILLTO_ADDRESS1" nvarchar(500), 
	"SHIPTO_CODE" nvarchar(50), 
	"SHIPTO_NAME" nvarchar(150), 
	"SHIPTO_FULLNAME" nvarchar(200), 
	"ADDRESS1" nvarchar(500), 
	"ADDRESS2" nvarchar(500), 
	"ADDRESS3" nvarchar(500), 
	"ADDRESS4" nvarchar(500), 
	"POSTAL_CODE" nvarchar(10), 
	"COUNTRY" nvarchar(2), 
	"CITY" nvarchar(50), 
	"BIZ_REG" nvarchar(30), 
	"SHIPTO_STATUS" nvarchar(1), 
	"MARKET_TYPE" nvarchar(3), 
	"SALES_CHANNEL" nvarchar(20), 
	"ACTIVE_FLAG" nvarchar(1), 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATA" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_SHOP_BILLTO
--------------------------------------------------------

  CREATE TABLE "TB_CM_SHOP_BILLTO" 
   (	"BILLTO_CODE" nvarchar(50), 
	"SHOP_CODE" nvarchar(10), 
	"CREATE_DATE" DATE, 
	"MODIFY_DATE" DATE, 
	"CREATE_USER" nvarchar(10), 
	"MODIFY_USER" nvarchar(10), 
	"USE_FLAG" nvarchar(1) DEFAULT 'Y', 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_SHOP_CELL
--------------------------------------------------------

  CREATE TABLE "TB_CM_SHOP_CELL" 
   (	"SHOP_ID" nvarchar(10), 
	"SHOP_CELL" nvarchar(20), 
	"CREATE_DATE" DATE, 
	"MODIFY_DATE" DATE, 
	"CREATE_USER" nvarchar(10), 
	"USE_FLAG" nvarchar(1) DEFAULT 'Y', 
	"MODIFY_USER" nvarchar(10), 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_SHOP_INF
--------------------------------------------------------

  CREATE TABLE "TB_CM_SHOP_INF" 
   (	"BILLTO_CODE" nvarchar(50), 
	"SHOP_CODE" nvarchar(8), 
	"SHOP_NAME" nvarchar(100), 
	"ADDRESS" nvarchar(500), 
	"CELL_NO#1" nvarchar(20), 
	"DIST_CODE" nvarchar(5), 
	"PROVINCE_CODE" nvarchar(5), 
	"CREATE_DATE" DATE, 
	"UPDATE_DATE" DATE, 
	"ISDN_NO" nvarchar(20), 
	"CUSTOMER_CODE" nvarchar(50), 
	"AREA_CODE" nvarchar(2), 
	"CELL_NO#2" nvarchar(20), 
	"OWNER_NAME" nvarchar(100), 
	"OWNER_EMAIL" nvarchar(100), 
	"USE_FLAG" nvarchar(1) DEFAULT 'Y', 
	"CHANNEL" nvarchar(1) DEFAULT 'N', 
	"REG_ID" nvarchar(2), 
	"CREATE_USER" nvarchar(10), 
	"UPDATE_USER" nvarchar(10), 
	"SHOP_TYPE" nvarchar(10) DEFAULT 'SUB-D', 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_SN_INF_DEC
--------------------------------------------------------

  CREATE TABLE "TB_CM_SN_INF_DEC" 
   (	"SN_LEN" nvarchar(2), 
	"SN_LEFT" nvarchar(2), 
	"SN_RIGHT" nvarchar(2), 
	"CREATE_DATE" DATE, 
	"UPDATE_DATE" DATE, 
	"USER_ID" nvarchar(16) DEFAULT 'PROC', 
	"SUB_CODE" nvarchar(50), 
	"MES_PROD" nvarchar(20), 
	"SET_BOX" nvarchar(1), 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_SUB_INF
--------------------------------------------------------

  CREATE TABLE "TB_CM_SUB_INF" 
   (	"SUB_CODE" nvarchar(15), 
	"SUB_NAME" nvarchar(100), 
	"PROD_CAT" nvarchar(500), 
	"PROD_ML" nvarchar(500), 
	"CREATE_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_SYS_LOG
--------------------------------------------------------

  CREATE TABLE "TB_CM_SYS_LOG" 
   (	"ID" nvarchar(20), 
	"ENTRY_USER_ID" nvarchar(9), 
	"TITLE" nvarchar(100), 
	"SEQ_KEY" nvarchar(100), 
	"ACTION1" nvarchar(800), 
	"ACTION2" nvarchar(800), 
	"ACTION3" nvarchar(800), 
	"ACTION4" nvarchar(800), 
	"ACTION5" nvarchar(800), 
	"ACTION6" nvarchar(500), 
	"ACTION7" nvarchar(500), 
	"ACTION8" nvarchar(500), 
	"ACTION9" nvarchar(500), 
	"ACTION10" nvarchar(500), 
	"ACTION11" nvarchar(500), 
	"ACTION12" nvarchar(500), 
	"ACTION13" nvarchar(500), 
	"ACTION14" nvarchar(500), 
	"ACTION15" nvarchar(500), 
	"ACTION16" nvarchar(500), 
	"ACTION17" nvarchar(500), 
	"ACTION18" nvarchar(500), 
	"ACTION19" nvarchar(500), 
	"ACTION20" nvarchar(500), 
	"ENTRY_DATE_TIME" DATE, 
	"REMARK" nvarchar(800)
   ) ;
--------------------------------------------------------
--  DDL for Table TB_DELIVERY_RDC_HIST
--------------------------------------------------------

  CREATE TABLE "TB_DELIVERY_RDC_HIST" 
   (	"INV_ORG" nvarchar(5), 
	"DELIVERY_NO" nvarchar(30), 
	"PLAN_NO" nvarchar(50), 
	"PICK_NO" nvarchar(25), 
	"SHIPTO_CODE" nvarchar(30), 
	"SHIPTO_NAME" nvarchar(1000), 
	"MODEL_SUFFIX" nvarchar(30), 
	"DELIVERY_ADDRESS" nvarchar(1000), 
	"DELIVERY_QTY" nvarchar(5), 
	"DELIVERY_DATE" DATE, 
	"UNIQUE_ID" nvarchar (6), 
	"LINE_ID" nvarchar(3), 
	"DELIVERY_STATUS" nvarchar(10), 
	"CREATE_DATE" DATE, 
	"SHIP_DATE" DATE, 
	"PICK_DATE" DATE, 
	"MODEL" nvarchar(20), 
	"SUFFIX" nvarchar(20)
   ) ;
--------------------------------------------------------
--  DDL for Table TB_EDI_HIST
--------------------------------------------------------

  CREATE TABLE "TB_EDI_HIST" 
   (	"UNIQUE_ID" nvarchar (6), 
	"EDI_FILENAME" nvarchar(100), 
	"EDI_USERNAME" nvarchar(50), 
	"EDI_MACHINENAME" nvarchar(50), 
	"ORG_SIDE" nvarchar(3), 
	"ROW_NUMERIC" nvarchar(8), 
	"END_TIME" DATE, 
	"START_TIME" DATE, 
	"EDI_DATE" DATE, 
	"EDI_MACADDRESS" nvarchar(50), 
	"EDI_FILESIZE" nvarchar(10) DEFAULT '0', 
	"EDI_SHEETNAME" nvarchar(50), 
	"EDI_STATUS" nvarchar(1) DEFAULT 'N', 
	"ORG_CODE" nvarchar(3), 
	"ITEM_ID" nvarchar(2), 
	"EDI_IPADDRESS" nvarchar(30), 
	"SUCCESS_CNT" nvarchar(10) DEFAULT '0', 
	"DUP_CNT" nvarchar(10) DEFAULT '0', 
	"DUP_ITEM" binary
   ) ;
    
--------------------------------------------------------
--  DDL for Table TB_EDI_ITEM
--------------------------------------------------------

  CREATE TABLE "TB_EDI_ITEM" 
   (	"ITEM_ID" nvarchar(2), 
	"ORG_SIDE" nvarchar(3), 
	"ITEM_NAME" nvarchar(40), 
	"CREATE_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_EDI_RESULT
--------------------------------------------------------

  CREATE TABLE "TB_EDI_RESULT" 
   (	"DUP_CNT" nvarchar(10), 
	"DONE_CNT" nvarchar(10), 
	"DUP_ITEM" binary, 
	"EDI_FILE" nvarchar(50), 
	"FAIL_CNT" nvarchar(10), 
	"FAIL_ITEM" binary, 
	"EDI_DATE" nvarchar(8), 
	"EDI_TIME" DATE, 
	"EDI_HEAD" nvarchar(10), 
	"EDI_CODE" nvarchar(10), 
	"NEW_CNT" nvarchar(10), 
	"DONE_ITEM" binary, 
	"RESPONSE" nvarchar(1) DEFAULT 'N'
   ) ;
--------------------------------------------------------
--  DDL for Table TB_FTP_MC
--------------------------------------------------------

  CREATE TABLE "TB_FTP_MC" 
   (	"MC_NAME" nvarchar(20), 
	"BILLTO_CODE" nvarchar(50), 
	"ID" nvarchar(50), 
	"PWD" nvarchar(50), 
	"CREATE_DATE" DATE, 
	"SEND_FOLDER" nvarchar(50), 
	"RECEIVE_FLODER" nvarchar(50)
   ) ;
--------------------------------------------------------
--  DDL for Table TB_LEVEL
--------------------------------------------------------

  CREATE TABLE "TB_LEVEL" 
   (	"ID" NUMERIC(10,0), 
	"CODE" nvarchar(100), 
	"NAME" nvarchar(100), 
	"REMARK" nvarchar(100), 
	"ENTRY_USER_ID" NUMERIC(10,0), 
	"ENTRY_USER_NAME" nvarchar(100), 
	"ENTRY_DATE_TIME" DATE, 
	"UPDATE_USER_ID" NUMERIC(10,0), 
	"UPDATE_USER_NAME" nvarchar(100), 
	"UPDATE_DATE_TIME" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_LEVEL_MENU
--------------------------------------------------------

  CREATE TABLE "TB_LEVEL_MENU" 
   (	"ID" NUMERIC(10,0), 
	"LEVEL_ID" NUMERIC(10,0), 
	"MENU_ID" NUMERIC(10,0), 
	"ENTRY_USER_ID" NUMERIC(10,0), 
	"ENTRY_USER_NAME" nvarchar(100), 
	"ENTRY_DATE_TIME" DATE, 
	"UPDATE_USER_ID" NUMERIC(10,0), 
	"UPDATE_USER_NAME" nvarchar(100), 
	"UPDATE_DATE_TIME" DATE
   ) ; 
--------------------------------------------------------
--  DDL for Table TB_MO_HIST
--------------------------------------------------------

  CREATE TABLE "TB_MO_HIST" 
   (	"CELL_NO" nvarchar(15), 
	"SHORTCODE" nvarchar(15) DEFAULT '8069', 
	"MOSEQ" nvarchar(20), 
	"CMDCODE" nvarchar(160), 
	"MSGBODY" nvarchar(160), 
	"RECEIVE_TIME" DATE, 
	"FILENAME" nvarchar(300), 
	"FILEDATE" nvarchar(20) DEFAULT null, 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE DEFAULT null, 
	"TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"TRANSFER_DATE" DATE, 
	"MO_SEQ" NUMERIC
   ) ;
    
--------------------------------------------------------
--  DDL for Table TB_MT_HIST
--------------------------------------------------------

  CREATE TABLE "TB_MT_HIST" 
   (	"MOSEQ" nvarchar(20), 
	"SHORTCODE" nvarchar(10) DEFAULT 'LG-CSKH', 
	"CELL_NO" nvarchar(15), 
	"MSGBODY" nvarchar(200), 
	"MSGTYPE" nvarchar(10) DEFAULT 'TEXT', 
	"MTTOTALSEQ" nvarchar(1) DEFAULT '1', 
	"MTSEQREF" nvarchar(1) DEFAULT '1', 
	"SEND_TIME" nvarchar(20), 
	"FINISH_TIME" nvarchar(20), 
	"SEND_FLAG" nvarchar(1) DEFAULT 'N', 
	"RESULT" nvarchar(4), 
	"LAST_UPDATE_DATE" DATE, 
	"CPID" nvarchar(5) DEFAULT '10312', 
	"CMDCODE" nvarchar(160), 
	"MO_MSGBODY" nvarchar(160), 
	"RESP_TYPE" nvarchar(10), 
	"MO_RECEIVE_TIME" DATE, 
	"CREATE_DATE" DATE, 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE, 
	"MT_SEQ" NUMERIC
   ) ;
    
--------------------------------------------------------
--  DDL for Table TB_MT_SEND
--------------------------------------------------------

  CREATE TABLE "TB_MT_SEND" 
   (	"MOSEQ" nvarchar(20), 
	"SHORTCODE" nvarchar(10) DEFAULT 'LG-CSKH', 
	"CELL_NO" nvarchar(15), 
	"MSGBODY" nvarchar(200), 
	"MSGTYPE" nvarchar(10) DEFAULT 'TEXT', 
	"MTTOTALSEQ" nvarchar(1) DEFAULT '1', 
	"MTSEQREF" nvarchar(1) DEFAULT '1', 
	"CPID" nvarchar(5) DEFAULT '10312', 
	"MT_SEQ" NUMERIC, 
	"SEND_FLAG" nvarchar(1) DEFAULT 0
   ) ;
--------------------------------------------------------
--  DDL for Table TB_MT_SMS_RESP_MSG
--------------------------------------------------------

  CREATE TABLE "TB_MT_SMS_RESP_MSG" 
   (	"RESP_TYPE" nvarchar(10), 
	"RESP_MSG#1" nvarchar(160), 
	"CREATE_DATE" DATE, 
	"MSGBODY_LEN" nvarchar(5), 
	"RESP_MSG#2" nvarchar(160), 
	"GABIT_TEMPLATE" nvarchar(160), 
	"GABIT_ID" nvarchar(5), 
	"TEMPLATE" nvarchar(160), 
	"PURPOSE" nvarchar(20), 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_NON_INCENTIVE_CUST
--------------------------------------------------------

  CREATE TABLE "TB_NON_INCENTIVE_CUST" 
   (	"BILLTO_CODE" nvarchar(50), 
	"BILLTO_NAME" nvarchar(200), 
	"TYPE" nvarchar(3), 
	"CHANNEL" nvarchar(15), 
	"REGION" nvarchar(2)
   ) ;
--------------------------------------------------------
--  DDL for Table TB_ORDER_SHIP_HIST
--------------------------------------------------------

  CREATE TABLE "TB_ORDER_SHIP_HIST" 
   (	"INV_ORG" nvarchar(3), 
	"SHIPTO_CODE" nvarchar(20), 
	"SHIPTO_NAME" nvarchar(200), 
	"CITY" nvarchar(20), 
	"ORDER_NO" nvarchar(12), 
	"LINE_NO" nvarchar(10), 
	"LINE_STATUS" nvarchar(50), 
	"PROD_DIV" nvarchar(20), 
	"MODEL_SUFFIX" nvarchar(30), 
	"ORDER_QTY" nvarchar(5), 
	"RELEASE_QTY" nvarchar(5), 
	"UNIT_SELL_PRICE" nvarchar(20) DEFAULT '0', 
	"ORDER_AMT" nvarchar(20) DEFAULT '0', 
	"SHIPPING_METHOD" nvarchar(50), 
	"REQUEST_SHIPPED_DATE" DATE, 
	"REQUEST_ARRIVAL_DATE" DATE, 
	"SHIPPING_REMARK" nvarchar(1000), 
	"INVOICE_NO" nvarchar(50), 
	"INVOICE_DATE" DATE, 
	"BOOKED_DATE" DATE, 
	"PICK_NO" nvarchar(30), 
	"PICK_RELEASE_DATE" DATE, 
	"DELIVERY_NO" nvarchar(40), 
	"SUBINVENTORY" nvarchar(20), 
	"CREATION_DATE" DATE, 
	"BILLTO_CODE" nvarchar(30), 
	"BILLTO_NAME" nvarchar(100), 
	"SALESCHANNEL_CODE" nvarchar(30), 
	"SALESCHANNEL_NAME" nvarchar(100), 
	"CREATED_BY" nvarchar(150), 
	"SALESPERSON" nvarchar(150), 
	"UNIQUE_ID" nvarchar (6), 
	"PICK_SEQ" nvarchar(2), 
	"MODEL" nvarchar(20), 
	"SUFFIX" nvarchar(20), 
	"AR_FLAG" nvarchar(1), 
	"AU_CODE" nvarchar(3), 
	"ACCEPTANCE_CODE" nvarchar(3), 
	"CARRIER" nvarchar(20), 
	"ORDER_TYPE_NAME" nvarchar(50), 
	"CANCEL_FLAG" nvarchar(1), 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_SN_CDC_HIST
--------------------------------------------------------

  CREATE TABLE "TB_SN_CDC_HIST" 
   (	"INV_ORG" nvarchar(3), 
	"LOADPLAN_NO" nvarchar(20), 
	"SERIAL_NO" nvarchar(50), 
	"BOX_NO" nvarchar(50), 
	"SHIPTO_CODE" nvarchar(20), 
	"SHIPTO_NAME" nvarchar(200), 
	"SHIPTO_DATE" DATE, 
	"ORDER_NO" nvarchar(12), 
	"CLOSED_DATE" DATE, 
	"INVOICE_NO" nvarchar(20), 
	"INVOICE_DATE" DATE, 
	"CUSTOMER_CODE" nvarchar(20), 
	"CUSTOMER_NAME" nvarchar(200), 
	"UNIQUE_ID" nvarchar (6) , 
	"SELLOUT_FLAG" nvarchar(1) DEFAULT 'N', 
	"SELLOUT_DATE" DATE, 
	"INCENTIVE_FLAG" nvarchar(1) DEFAULT 'N', 
	"WARRANTY_IF_FLAG" nvarchar(1) DEFAULT 'N', 
	"WARRANTY_IF_DATE" DATE, 
	"SEQ_NO" nvarchar(3), 
	"MODEL_SUFFIX" nvarchar(50), 
	"MODEL" nvarchar(20), 
	"SUFFIX" nvarchar(20), 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_SN_INSTALLER
--------------------------------------------------------

  CREATE TABLE "TB_SN_INSTALLER" 
   (	"ISL_CODE" nvarchar(10), 
	"ISL_CELL" nvarchar(20), 
	"SERIAL_NO" nvarchar(20), 
	"MODEL" nvarchar(50), 
	"SELLIN_DATE" DATE, 
	"SELLOUT_DATE" DATE, 
	"ISL_DATE" DATE, 
	"INC_CFM_FLAG" nvarchar(1) DEFAULT 'N', 
	"ICN_CFM_USER" nvarchar(10), 
	"RESP_MSG" nvarchar(200), 
	"RESP_TYPE" nvarchar(10), 
	"SUFFIX" nvarchar(20), 
	"CMDCODE" nvarchar(10), 
	"MOSEQ" nvarchar(20), 
	"EU_CELL" nvarchar(20)
   ) ;
--------------------------------------------------------
--  DDL for Table TB_SN_PND_HIST
--------------------------------------------------------

  CREATE TABLE "TB_SN_PND_HIST" 
   (	"SERIAL_NO" nvarchar(50), 
	"MOSEQ" nvarchar(20), 
	"RESP_TYPE" nvarchar(10), 
	"CMDCODE" nvarchar(4), 
	"RECEIVE_DATE" DATE, 
	"PND_DAYS" NUMERIC(3,0), 
	"CFM_FLAG" nvarchar(1) DEFAULT 'N', 
	"CFM_TYPE" nvarchar(10), 
	"CFM_DATE" DATE, 
	"SHOP_CELL" nvarchar(20), 
	"RESP_MSG" nvarchar(200), 
	"MODEL" nvarchar(50), 
	"CFM_USER" nvarchar(10), 
	"MO_MSGBODY" nvarchar(160), 
	"END_USER_CELL" nvarchar(20), 
	"PND_TYPE" nvarchar(10), 
	"SHOP_CODE" nvarchar(10), 
	"SMS_YN" nvarchar(1) DEFAULT 'Y', 
	"REJECT_FLAG" nvarchar(1) DEFAULT 'N', 
	"REJECT_DATE" DATE, 
	"REJECT_USER" nvarchar(10), 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_SN_RDC_HIST
--------------------------------------------------------

  CREATE TABLE "TB_SN_RDC_HIST" 
   (	"INV_ORG" nvarchar(5), 
	"EDI_NO" nvarchar(16), 
	"SERIAL_NO" nvarchar(100), 
	"BOX_NO" nvarchar(100), 
	"MODEL_SUFFIX" nvarchar(20), 
	"MODEL" nvarchar(20), 
	"SUFFIX" nvarchar(20), 
	"SHIP_NO" nvarchar(18), 
	"LINE_NO" nvarchar(3), 
	"OUT_DATE" DATE, 
	"CREATE_DATE" DATE, 
	"SELLOUT_DATE" DATE, 
	"INCENTIVE_DATE" DATE, 
	"WT_IF_DATE" DATE, 
	"WT_IF_FLAG" nvarchar(1) DEFAULT 'N', 
	"SELLOUT_STATUS" nvarchar(1) DEFAULT 'N', 
	"INCENTIVE_FLAG" nvarchar(1) DEFAULT 'N', 
	"SMS_YN" nvarchar(1) DEFAULT 'Y', 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_SN_SO_DEALERS
--------------------------------------------------------

  CREATE TABLE "TB_SN_SO_DEALERS" 
   (	"SHOP_CODE" nvarchar(8), 
	"SERIAL_NO" nvarchar(50), 
	"BOX_NO" nvarchar(100), 
	"MODEL" nvarchar(100), 
	"MODEL_DESC" nvarchar(200), 
	"EDI_NO" nvarchar(30), 
	"SELLOUT_DATE" DATE, 
	"EU_CELL" nvarchar(20), 
	"EU_NAME" nvarchar(100), 
	"EU_ADDRESS" nvarchar(500), 
	"UPDATE_DATE" DATE, 
	"UPLOAD_USER" nvarchar(8), 
	"VRF_FLAG" nvarchar(1) DEFAULT 'N', 
	"SUFFIX" nvarchar(20), 
	"CFM_FLAG" nvarchar(1) DEFAULT 'N', 
	"CFM_USER" nvarchar(8), 
	"CFM_DATE" DATE, 
	"CFM_COMMENT" nvarchar(500), 
	"SELLIN_DATE" DATE, 
	"EDI_DATE" nvarchar(8), 
	"EDI_FILE" nvarchar(50)
   ) ;
--------------------------------------------------------
--  DDL for Table TB_SN_SO_WT_HIST
--------------------------------------------------------

  CREATE TABLE "TB_SN_SO_WT_HIST" 
   (	"SERIAL_NO" nvarchar(50), 
	"MODEL" nvarchar(50), 
	"END_USER_CELL" nvarchar(20), 
	"SHOP_CODE" nvarchar(10), 
	"SHOP_CELL" nvarchar(20), 
	"RECEIVE_DATE" DATE, 
	"MOSEQ" nvarchar(30), 
	"CMDCODE" nvarchar(4), 
	"RESP_TYPE" nvarchar(10), 
	"RESP_MSG" nvarchar(200), 
	"MO_MSGBODY" nvarchar(160), 
	"SMS_YN" nvarchar(1) DEFAULT 'Y', 
	"CREATE_DATE" DATE, 
	"SUCCESS_FLAG" nvarchar(1) DEFAULT 'N', 
	"EDI_FILE" nvarchar(50), 
	"EDI_HEAD" nvarchar(10), 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_SN_SO_WT_MST
--------------------------------------------------------

  CREATE TABLE "TB_SN_SO_WT_MST" 
   (	"SERIAL_NO" nvarchar(20), 
	"SELLIN_DATE" DATE, 
	"SELLOUT_DATE" DATE, 
	"WT_START_DATE" DATE, 
	"WT_END_DATE" DATE, 
	"SHOP_CODE" nvarchar(10), 
	"SHOP_CELL" nvarchar(20), 
	"SELLOUT_RESP_MSG" nvarchar(160), 
	"POINT" nvarchar(10), 
	"AMT" nvarchar(10), 
	"SELLOUT_RESP_TYPE" nvarchar(10), 
	"SELLOUT_TIME" nvarchar(8), 
	"INCENTIVE_CFM_FLAG" nvarchar(1) DEFAULT 'N', 
	"INCENTIVE_CFM_DATE" DATE, 
	"MODEL" nvarchar(50), 
	"SUFFIX" nvarchar(20), 
	"CLOSE_FLAG" nvarchar(1) DEFAULT 'N', 
	"CLOSE_PERIOD" nvarchar(10), 
	"SMS_YN" nvarchar(1) DEFAULT 'Y', 
	"CREATE_DATE" DATE, 
	"INCENTIVE_CFM_USER" nvarchar(10) DEFAULT 'SYS', 
	"CLOSE_USER" nvarchar(10), 
	"INCENTIVE_CFM_PERIOD" nvarchar(12), 
	"LAST_UPDATE_DATE" DATE, 
	"END_USER_CELL" nvarchar(20), 
	"TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"TRANSFER_DATE" DATE, 
	"SO_TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_SN_SO_WT_MST0
--------------------------------------------------------

  CREATE TABLE "TB_SN_SO_WT_MST0" 
   (	"MODEL" nvarchar(50), 
	"SUFFIX" nvarchar(20), 
	"SERIAL_NO" nvarchar(20), 
	"WT_START_DATE" DATE, 
	"WT_END_DATE" DATE, 
	"END_USER_CELL" nvarchar(20), 
	"WT_RESP_MSG" nvarchar(160), 
	"WT_RESP_TYPE" nvarchar(10), 
	"SMS_YN" nvarchar(1) DEFAULT 'Y', 
	"CREATE_DATE" DATE, 
	"WT_CFM_USER" nvarchar(10) DEFAULT 'SYS', 
	"LAST_UPDATE_DATE" DATE, 
	"SELLIN_DATE" DATE, 
	"SELLOUT_DATE" DATE, 
	"SELLOUT_TIME" nvarchar(6), 
	"TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_SUB_MENU
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table TB_USER
--------------------------------------------------------

  CREATE TABLE "TB_USER" 
   (	"ID" NUMERIC(10,0), 
	"EMPNO" nvarchar(80), 
	"ACCOUNT" nvarchar(80), 
	"PASS" nvarchar(400), 
	"DISPLAY_NAME" nvarchar(80), 
	"ACTIVE" NUMERIC(1,0), 
	"AVATAR" nvarchar(2000), 
	"ENTRY_USER_ID" NUMERIC(10,0), 
	"ENTRY_USER_NAME" nvarchar(100), 
	"ENTRY_DATE_TIME" DATE, 
	"UPDATE_USER_ID" NUMERIC(10,0), 
	"UPDATE_USER_NAME" nvarchar(100), 
	"UPDATE_DATE_TIME" DATE, 
	"REGION_ID" nvarchar(2) DEFAULT '00'
   ) ;
--------------------------------------------------------
--  DDL for Table TB_USER_LEVEL
--------------------------------------------------------

  CREATE TABLE "TB_USER_LEVEL" 
   (	"ID" NUMERIC(10,0), 
	"USER_ID" NUMERIC(10,0), 
	"LEVEL_ID" NUMERIC(10,0), 
	"ENTRY_USER_ID" NUMERIC(10,0), 
	"ENTRY_USER_NAME" nvarchar(100), 
	"ENTRY_DATE_TIME" DATE, 
	"UPDATE_USER_ID" NUMERIC(10,0), 
	"UPDATE_USER_NAME" nvarchar(100), 
	"UPDATE_DATE_TIME" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_USER_MENU
--------------------------------------------------------

  CREATE TABLE "TB_USER_MENU" 
   (	"ID" NUMERIC(10,0), 
	"USER_ID" NUMERIC(10,0), 
	"MENU_ID" NUMERIC(10,0), 
	"ENTRY_USER_ID" NUMERIC(10,0), 
	"ENTRY_USER_NAME" nvarchar(100), 
	"ENTRY_DATE_TIME" DATE, 
	"UPDATE_USER_ID" NUMERIC(10,0), 
	"UPDATE_USER_NAME" nvarchar(100), 
	"UPDATE_DATE_TIME" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table VNXX_DELIVERY_RDC_HIST_IF
--------------------------------------------------------

  CREATE TABLE "VNXX_DELIVERY_RDC_HIST_IF" 
   (	"INV_ORG" nvarchar(5), 
	"DELIVERY_NO" nvarchar(30), 
	"PLAN_NO" nvarchar(50), 
	"PICK_NO" nvarchar(25), 
	"SHIPTO_CODE" nvarchar(25), 
	"SHIPTO_NAME" nvarchar(1000), 
	"MODEL_SUFFIX" nvarchar(30), 
	"DELIVERY_ADDRESS" nvarchar(1000), 
	"DELIVERY_QTY" nvarchar(5), 
	"DELIVERY_DATE" DATE, 
	"IF_UNIQUE_ID" nvarchar (6), 
	"TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"TRANSFER_STATUS" nvarchar(1) DEFAULT 'N', 
	"TRANSFER_DATE" DATE, 
	"LINE_ID" nvarchar(3), 
	"DELIVERY_STATUS" nvarchar(10), 
	"SHIP_DATE" DATE, 
	"PICK_DATE" DATE, 
	"MODEL" nvarchar(20), 
	"SUFFIX" nvarchar(20)
   ) ;
--------------------------------------------------------
--  DDL for Table VNXX_EDI_RESULT
--------------------------------------------------------

  CREATE TABLE "VNXX_EDI_RESULT" 
   (	"EDI_DATE" nvarchar(8), 
	"EDI_TIME" DATE, 
	"EDI_TYPE" nvarchar(6), 
	"DUP_CNT" nvarchar(10), 
	"NEW_CNT" nvarchar(10), 
	"DUP_ITEM" binary
   ) ;
--------------------------------------------------------
--  DDL for Table VNXX_ORDER_SHIP_HIST_IF
--------------------------------------------------------

  CREATE TABLE "VNXX_ORDER_SHIP_HIST_IF" 
   (	"INV_ORG" nvarchar(3), 
	"SHIPTO_CODE" nvarchar(20), 
	"SHIPTO_NAME" nvarchar(200), 
	"CITY" nvarchar(20), 
	"ORDER_NO" nvarchar(12), 
	"PROD_DIV" nvarchar(50), 
	"MODEL_SUFFIX" nvarchar(30), 
	"ORDER_QTY" nvarchar(5), 
	"RELEASE_QTY" nvarchar(5) DEFAULT '0', 
	"UNIT_SELL_PRICE" nvarchar(20) DEFAULT '0', 
	"ORDER_AMT" nvarchar(20) DEFAULT '0', 
	"SHIPPING_METHOD" nvarchar(50), 
	"REQUEST_SHIPPED_DATE" DATE, 
	"REQUEST_ARRIVAL_DATE" DATE, 
	"SHIPPING_REMARK" nvarchar(1000), 
	"INVOICE_NO" nvarchar(50), 
	"INVOICE_DATE" DATE, 
	"BOOKED_DATE" DATE, 
	"PICK_NO" nvarchar(30), 
	"PICK_RELEASE_DATE" DATE, 
	"DELIVERY_NO" nvarchar(40), 
	"SUBINVENTORY" nvarchar(20), 
	"CREATION_DATE" DATE, 
	"BILLTO_CODE" nvarchar(30), 
	"BILLTO_NAME" nvarchar(100), 
	"SALESCHANNEL_CODE" nvarchar(30), 
	"SALESCHANNEL_NAME" nvarchar(100), 
	"CREATED_BY" nvarchar(150), 
	"LINE_STATUS" nvarchar(50), 
	"SALESPERSON" nvarchar(150), 
	"UNIQUE_ID" nvarchar (6), 
	"TRANSFER_DATE" DATE, 
	"TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"TRANSFER_STATUS" nvarchar(1) DEFAULT 'N', 
	"LINE_NO" nvarchar(10), 
	"PICK_SEQ" nvarchar(2), 
	"MODEL" nvarchar(20), 
	"SUFFIX" nvarchar(20)
   ) ;
--------------------------------------------------------
--  DDL for Table VNXX_SHPCFM_IF
--------------------------------------------------------

  CREATE TABLE "VNXX_SHPCFM_IF" 
   (	"INTERFACE_ID" NUMERIC, 
	"OPERATING_UNIT_ID" NUMERIC, 
	"SOURCE_TYPE_CODE" nvarchar(30), 
	"ORGANIZATION_CODE" nvarchar(3), 
	"PICK_ORDER_NO" nvarchar(30), 
	"TRANSACTION_DATE" DATE, 
	"CANCEL_FLAG" nvarchar(1), 
	"TRANSFER_FLAG" nvarchar(1), 
	"TRANSFER_DATE" DATE, 
	"GLOBAL_UNIQUE_ID" nvarchar(100), 
	"BAM_SEQUENCE_ID" NUMERIC, 
	"OLD_GLOBAL_UNIQUE_ID" nvarchar(100), 
	"EDI_SENDER_ID" nvarchar(50), 
	"EDI_RECEIVER_ID" nvarchar(50), 
	"EDI_SUB_SENDER_ID" nvarchar(50), 
	"EDI_SUB_RECEIVER_ID" nvarchar(50), 
	"EDI_ENVELOPE_NO" nvarchar(50), 
	"EDI_GROUP_NO" nvarchar(50), 
	"EDI_TRANSACTION_NO" nvarchar(50), 
	"STEP_CODE" nvarchar(30), 
	"STEP_STATUS_CODE" nvarchar(30), 
	"EDI_INTERFACE_DATE" DATE, 
	"EDI_FUNC_ACKNOWLDG_NO" nvarchar(70), 
	"EDI_FUNC_ACKNOWLDG_DATE" DATE, 
	"EDI_FUNC_ACKNOWLDG_STATUS_CODE" nvarchar(5), 
	"EDI_ERROR_CODE" nvarchar(20), 
	"EDI_ERROR_MESSAGE_TEXT" nvarchar(4000), 
	"DELIVERY_NO" nvarchar(30), 
	"LOAD_CONFIRM_NO" nvarchar(30), 
	"PICK_SEQ_NO" NUMERIC, 
	"SOURCE_HEADER_ID" NUMERIC, 
	"SOURCE_HEADER_NO" nvarchar(30), 
	"SHIP_TO_CUSTOMER_CODE" nvarchar(11), 
	"APPOINTMENT_FROM_DATE" DATE, 
	"APPOINTMENT_TO_DATE" DATE, 
	"SUBINVENTORY_CODE" nvarchar(10), 
	"CARRIER_CODE" nvarchar(9), 
	"CUSTOMER_PURCHASE_ORDER_NO" nvarchar(30), 
	"TRUCK_NO" nvarchar(20), 
	"SEAL_NO" nvarchar(50), 
	"DRIVER_NAME" nvarchar(40), 
	"FREIGHT_AMOUNT" NUMERIC(22,2), 
	"SOURCE_LINE_ID" NUMERIC, 
	"SOURCE_LINE_NO" NUMERIC, 
	"SHIPMENT_NO" NUMERIC, 
	"OPTION_NO" NUMERIC, 
	"MOVE_ORDER_LINE_ID" NUMERIC, 
	"ITEM_CODE" nvarchar(40), 
	"PICK_QTY" nvarchar(9), 
	"DELIVERY_QTY" nvarchar(9), 
	"SHORTAGE_SHIPPING_REASON_CODE" nvarchar(3), 
	"WMS_ORDER_NO" nvarchar(10), 
	"WMS_CREATION_USER_NAME" nvarchar(50), 
	"WMS_CREATION_DATE" DATE, 
	"TRANSPORTATION_WAYBILL_NO" nvarchar(50), 
	"REMARK1_DESC" nvarchar(250), 
	"WMS_ORDER_SEQ_NO" nvarchar(5), 
	"ATTRIBUTE5" nvarchar(150), 
	"TOTAL_COUNT" NUMERIC
   ) ;
    
--------------------------------------------------------
--  DDL for Table VNXX_SHPSERIAL_IF
--------------------------------------------------------

  CREATE TABLE "VNXX_SHPSERIAL_IF" 
   (	"SERIAL_TRANSACTION_ID" NUMERIC, 
	"SOURCE_TYPE_CODE" nvarchar(30), 
	"OPERATING_UNIT_ID" NUMERIC, 
	"ORGANIZATION_CODE" nvarchar(3), 
	"SOURCE_HEADER_ID" NUMERIC, 
	"SOURCE_HEADER_NO" nvarchar(30), 
	"SOURCE_LINE_ID" NUMERIC, 
	"SOURCE_LINE_NO" NUMERIC, 
	"MOVE_ORDER_LINE_ID" NUMERIC, 
	"PICK_ORDER_NO" nvarchar(30), 
	"PICK_SEQ_NO" NUMERIC, 
	"DELIVERY_NO" nvarchar(30), 
	"LOAD_CONFIRM_NO" nvarchar(30), 
	"SHIPPING_SEQ_NO" NUMERIC, 
	"ITEM_CODE" nvarchar(50), 
	"SERIAL_NO" nvarchar(30), 
	"PACKING_ID" nvarchar(20), 
	"PACKING_TYPE" nvarchar(1), 
	"CANCEL_FLAG" nvarchar(1), 
	"TRANSFER_FLAG" nvarchar(1), 
	"TRANSFER_DATE" DATE, 
	"GLOBAL_UNIQUE_ID" nvarchar(100), 
	"BAM_SEQUENCE_ID" NUMERIC, 
	"OLD_GLOBAL_UNIQUE_ID" nvarchar(100), 
	"EDI_SENDER_ID" nvarchar(50), 
	"EDI_RECEIVER_ID" nvarchar(50), 
	"EDI_SUB_SENDER_ID" nvarchar(50), 
	"EDI_SUB_RECEIVER_ID" nvarchar(50), 
	"EDI_ENVELOPE_NO" nvarchar(50), 
	"EDI_GROUP_NO" nvarchar(50), 
	"EDI_TRANSACTION_NO" nvarchar(50), 
	"STEP_CODE" nvarchar(30), 
	"STEP_STATUS_CODE" nvarchar(30), 
	"EDI_INTERFACE_DATE" DATE, 
	"EDI_FUNC_ACKNOWLDG_NO" nvarchar(70), 
	"EDI_FUNC_ACKNOWLDG_DATE" DATE, 
	"EDI_FUNC_ACKNOWLDG_STATUS_CODE" nvarchar(5), 
	"EDI_ERROR_CODE" nvarchar(20), 
	"EDI_ERROR_MESSAGE_TEXT" nvarchar(4000)
   ) ; 
--------------------------------------------------------
--  DDL for Table VNXX_SN_CBU_HIST_IF
--------------------------------------------------------

  CREATE TABLE "VNXX_SN_CBU_HIST_IF" 
   (	"LOT_ID" nvarchar(30), 
	"MODEL_CODE" nvarchar(20), 
	"SUFFIX" nvarchar(20), 
	"LOT_BOX" nvarchar(50), 
	"LOT_SET" nvarchar(50), 
	"TRANSFER_DATE" DATE, 
	"SUB_CODE" nvarchar(20)
   ) ;
--------------------------------------------------------
--  DDL for Table VNXX_SN_CDC_HIST_IF
--------------------------------------------------------

  CREATE TABLE "VNXX_SN_CDC_HIST_IF" 
   (	"INV_ORG" nvarchar(3), 
	"LOADPLAN_NO" nvarchar(20), 
	"SERIAL_NO" nvarchar(50), 
	"BOX_NO" nvarchar(50), 
	"SHIPTO_CODE" nvarchar(20), 
	"SHIPTO_NAME" nvarchar(200), 
	"SHIPTO_DATE" DATE, 
	"ORDER_NO" nvarchar(12), 
	"CLOSED_DATE" DATE, 
	"INVOICE_NO" nvarchar(20), 
	"INVOICE_DATE" DATE, 
	"CUSTOMER_CODE" nvarchar(20), 
	"CUSTOMER_NAME" nvarchar(200), 
	"TRANSFER_DATE" DATE, 
	"TRANSFER_STATUS" nvarchar(1) DEFAULT 'N', 
	"TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"UNIQUE_ID" nvarchar (6), 
	"SEQ_NO" nvarchar(3), 
	"MODEL_SUFFIX" nvarchar(30), 
	"MODEL" nvarchar(20), 
	"SUFFIX" nvarchar(20)
   ) ;
--------------------------------------------------------
--  DDL for Table VNXX_SN_RDC_HIST_IF
--------------------------------------------------------

  CREATE TABLE "VNXX_SN_RDC_HIST_IF" 
   (	"INV_ORG" nvarchar(5), 
	"EDI_NO" nvarchar(16), 
	"SERIAL_NO" nvarchar(100), 
	"BOX_NO" nvarchar(100), 
	"MODEL_SUFFIX" nvarchar(20), 
	"MODEL" nvarchar(20), 
	"SUFFIX" nvarchar(20), 
	"SHIP_NO" nvarchar(18), 
	"LINE_NO" nvarchar(3), 
	"OUT_DATE" DATE, 
	"TRANSFER_DATE" DATE, 
	"TRANSFER_FLAG" nvarchar(1) DEFAULT 'N', 
	"TRANSFER_STATUS" nvarchar(1) DEFAULT 'N'
   ) ;
--------------------------------------------------------
--  DDL for Table VXH_ORDER_SHIP_HIST
--------------------------------------------------------

  CREATE TABLE "VXH_ORDER_SHIP_HIST" 
   (	"INV_ORG" nvarchar(3), 
	"SHIPTO_CODE" nvarchar(20), 
	"SHIPTO_NAME" nvarchar(200), 
	"CITY" nvarchar(20), 
	"ORDER_NO" nvarchar(12), 
	"LINE_NO" nvarchar(10), 
	"LINE_STATUS" nvarchar(50), 
	"PROD_DIV" nvarchar(20), 
	"MODEL_SUFFIX" nvarchar(30), 
	"ORDER_QTY" nvarchar(5), 
	"RELEASE_QTY" nvarchar(5), 
	"UNIT_SELL_PRICE" nvarchar(20) DEFAULT '0', 
	"ORDER_AMT" nvarchar(20) DEFAULT '0', 
	"INVOICE_NO" nvarchar(50), 
	"PICK_NO" nvarchar(30), 
	"DELIVERY_NO" nvarchar(40), 
	"SUBINVENTORY" nvarchar(20), 
	"BILLTO_CODE" nvarchar(30), 
	"BILLTO_NAME" nvarchar(100), 
	"MODEL" nvarchar(20), 
	"SUFFIX" nvarchar(20)
   ) ;
--------------------------------------------------------
--  DDL for Table XVH_ORDER_TEMP
--------------------------------------------------------

  CREATE TABLE "XVH_ORDER_TEMP" 
   (	"EDI_NO" nvarchar(50), 
	"SHIPTO_CODE" nvarchar(100), 
	"SHIPTO_NAME" nvarchar(200), 
	"MODEL_SUFFIX" nvarchar(50), 
	"BILLTO_CODE" nvarchar(100), 
	"BILLTO_NAME" nvarchar(200), 
	"SHIP_DATE" nvarchar(10), 
	"DEL_DATE" nvarchar(10), 
	"ARV_DATE" nvarchar(10), 
	"QTY" nvarchar(10), 
	"ORDER_NO" nvarchar(30), 
	"LINE_NO" nvarchar(5), 
	"INV_ORG" nvarchar(3), 
	"LINE_STATUS" nvarchar(10), 
	"RELEASE_QTY" nvarchar(10)
   ) ;
--------------------------------------------------------
--  DDL for Table XVH_SN_RDC_HIST
--------------------------------------------------------

  CREATE TABLE "XVH_SN_RDC_HIST" 
   (	"INV_ORG" nvarchar(5), 
	"EDI_NO" nvarchar(16), 
	"SERIAL_NO" nvarchar(100), 
	"BOX_NO" nvarchar(100), 
	"MODEL_SUFFIX" nvarchar(20), 
	"MODEL" nvarchar(20), 
	"SUFFIX" nvarchar(20), 
	"SHIP_NO" nvarchar(28), 
	"LINE_NO" nvarchar(3), 
	"OUT_DATE" nvarchar(8)
   ) ;
--------------------------------------------------------
--  DDL for Table XVH_SN_TEMP
--------------------------------------------------------

  CREATE TABLE "XVH_SN_TEMP" 
   (	"SERIAL_NO" nvarchar(50), 
	"EDI_NO" nvarchar(50), 
	"LINE_NO" nvarchar(5), 
	"MODEL_SUFFIX" nvarchar(50), 
	"WH_DATE" nvarchar(20), 
	"WT_START_DT" nvarchar(8), 
	"WT_END_DT" nvarchar(8)
   ) ;
--------------------------------------------------------
--  DDL for Table XVH_TEMP
--------------------------------------------------------

  CREATE TABLE "XVH_TEMP" 
   (	"SERIAL_NO" nvarchar(30), 
	"MODEL_SUFFIX" nvarchar(50), 
	"PRODUCT" nvarchar(10), 
	"WT_START_DATE" DATE, 
	"WT_END_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table XX_TEMP
--------------------------------------------------------

  CREATE TABLE "XX_TEMP" 
   (	"LOT_BOX" nvarchar(60)
   ) ;
--------------------------------------------------------
--  DDL for Index PK_AC_INST_INF
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_AC_INST_INF" ON "TB_CM_AC_INSTALLER_INF" ("INST_CODE") 
  ;
--------------------------------------------------------
--  DDL for Index TB_CM_BILLTO_INF_PR_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_CM_BILLTO_INF_PR_PK" ON "TB_CM_BILLTO_INF" ("BILLTO_CODE") 
  ;
--------------------------------------------------------
--  DDL for Index SYS_C0013688
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0013688" ON "TB_CM_DISTRICT" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index TB_CM_INCENTIVE_ADHOC_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_CM_INCENTIVE_ADHOC_PK" ON "TB_CM_INCENTIVE_ADHOC" ("SCHEME_ID", "SCHEME_NAME") 
  ;
--------------------------------------------------------
--  DDL for Index PK_CM_INT_ADHOC_DETAIL_PR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_CM_INT_ADHOC_DETAIL_PR" ON "TB_CM_INCENTIVE_ADHOC_DETAIL" ("SCHEME_ID", "BILLTO_CODE", "MODEL") 
  ;
--------------------------------------------------------
--  DDL for Index TB_INCENTIVE_BALANCE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_INCENTIVE_BALANCE_PK" ON "TB_CM_INCENTIVE_BALANCE" ("YYYYMM", "SCHEME_ID", "SHOP_CODE", "MODEL") 
  ;
--------------------------------------------------------
--  DDL for Index TB_CM_SO_CLOSE_MST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_CM_SO_CLOSE_MST_PK" ON "TB_CM_INCENTIVE_CLOSE_MST" ("CLOSE_PERIOD") 
  ;
--------------------------------------------------------
--  DDL for Index TB_CM_INCENTIVE_MST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_CM_INCENTIVE_MST_PK" ON "TB_CM_INCENTIVE_MST" ("SCHEME_ID", "SCHEME_NAME") 
  ;
--------------------------------------------------------
--  DDL for Index PK_MODEL_MPR_PR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_MODEL_MPR_PR" ON "TB_CM_MRP" ("MODEL") 
  ;
--------------------------------------------------------
--  DDL for Index TB_CM_ORG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_CM_ORG_PK" ON "TB_CM_ORGANIZATION" ("ORG_CODE") 
  ;
--------------------------------------------------------
--  DDL for Index SYS_C0013685
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0013685" ON "TB_CM_PROVINCE" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index TB_CM_SHIPTO_INF_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_CM_SHIPTO_INF_PK" ON "TB_CM_SHIPTO_INF" ("SHIPTO_CODE") 
  ;
--------------------------------------------------------
--  DDL for Index TB_CM_SHOP_BILLTO_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_CM_SHOP_BILLTO_PK" ON "TB_CM_SHOP_BILLTO" ("BILLTO_CODE", "SHOP_CODE", "USE_FLAG") 
  ;
--------------------------------------------------------
--  DDL for Index TB_CM_SHOP_CELL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_CM_SHOP_CELL_PK" ON "TB_CM_SHOP_CELL" ("SHOP_CELL") 
  ;
--------------------------------------------------------
--  DDL for Index PK_SHOP_INF_PR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SHOP_INF_PR" ON "TB_CM_SHOP_INF" ("SHOP_CODE") 
  ;
--------------------------------------------------------
--  DDL for Index SYS_C0019294
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0019294" ON "TB_CM_SYS_LOG" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index TB_DELIVERY_WH_HIST_PR_KEY
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_DELIVERY_WH_HIST_PR_KEY" ON "TB_DELIVERY_RDC_HIST" ("PICK_NO", "LINE_ID", "PLAN_NO", "DELIVERY_QTY", "DELIVERY_DATE", "MODEL", "SUFFIX", "SHIPTO_CODE") 
  ;
--------------------------------------------------------
--  DDL for Index TB_EDI_HIST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_EDI_HIST_PK" ON "TB_EDI_HIST" ("EDI_FILENAME", "ORG_CODE", "START_TIME") 
  ;
--------------------------------------------------------
--  DDL for Index TB_EDI_ITEM_PR_KEY
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_EDI_ITEM_PR_KEY" ON "TB_EDI_ITEM" ("ITEM_ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_TB_FTP_MC_PR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_TB_FTP_MC_PR" ON "TB_FTP_MC" ("MC_NAME") 
  ;
--------------------------------------------------------
--  DDL for Index SYS_C0013633
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0013633" ON "TB_LEVEL" ("ID") 
  ;
--------------------------------------------------------
--  DDL for Index SYS_C0013683
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0013683" ON "TB_LEVEL_MENU" ("ID") 
  ; 
--------------------------------------------------------
--  DDL for Index PK_MT_SEQ_PR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_MT_SEQ_PR" ON "TB_MT_SEND" ("MT_SEQ") 
  ;
--------------------------------------------------------
--  DDL for Index TB_MT_SMS_REP_MSG_PR_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_MT_SMS_REP_MSG_PR_PK" ON "TB_MT_SMS_RESP_MSG" ("RESP_TYPE") 
  ;
--------------------------------------------------------
--  DDL for Index TB_NON_INCENTIVE_CUST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_NON_INCENTIVE_CUST_PK" ON "TB_NON_INCENTIVE_CUST" ("BILLTO_CODE") 
  ;
--------------------------------------------------------
--  DDL for Index PK_ORDER_SHIP_HIST_PR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_ORDER_SHIP_HIST_PR" ON "TB_ORDER_SHIP_HIST" ("INV_ORG", "SHIPTO_CODE", "ORDER_NO", "LINE_NO", "ORDER_QTY", "RELEASE_QTY", "REQUEST_ARRIVAL_DATE", "MODEL", "SUFFIX") 
  ;
--------------------------------------------------------
--  DDL for Index TB_ORDER_NO_IDX
--------------------------------------------------------

  CREATE INDEX "TB_ORDER_NO_IDX" ON "TB_ORDER_SHIP_HIST" ("ORDER_NO") 
  ;
--------------------------------------------------------
--  DDL for Index TB_SN_CDC_HIST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_SN_CDC_HIST_PK" ON "TB_SN_CDC_HIST" ("INV_ORG", "ORDER_NO", "SHIPTO_CODE", "MODEL", "SERIAL_NO", "SUFFIX") 
  ;
--------------------------------------------------------
--  DDL for Index PK_SN_INSTALLER
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SN_INSTALLER" ON "TB_SN_INSTALLER" ("SERIAL_NO", "MODEL") 
  ;
--------------------------------------------------------
--  DDL for Index TB_SN_PND_HIST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_SN_PND_HIST_PK" ON "TB_SN_PND_HIST" ("SERIAL_NO", "PND_TYPE") 
  ;
--------------------------------------------------------
--  DDL for Index TB_SN_RDC_HIST_IDX
--------------------------------------------------------

  CREATE INDEX "TB_SN_RDC_HIST_IDX" ON "TB_SN_RDC_HIST" ("SERIAL_NO", "MODEL") 
  ;
--------------------------------------------------------
--  DDL for Index TB_SN__RDC_HIST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_SN__RDC_HIST_PK" ON "TB_SN_RDC_HIST" ("SERIAL_NO", "OUT_DATE", "EDI_NO", "INV_ORG", "MODEL", "SUFFIX") 
  ;
--------------------------------------------------------
--  DDL for Index TB_SN_SO_WT_MST_PR_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_SN_SO_WT_MST_PR_PK" ON "TB_SN_SO_WT_MST" ("SERIAL_NO", "MODEL") 
  ;
--------------------------------------------------------
--  DDL for Index TB_SN_SO_WT_MST0_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TB_SN_SO_WT_MST0_PK" ON "TB_SN_SO_WT_MST0" ("SERIAL_NO", "MODEL") 
  ;
--------------------------------------------------------
--  DDL for Index VNXX_DELIVERY_HIST_PR_KEY
--------------------------------------------------------

  CREATE UNIQUE INDEX "VNXX_DELIVERY_HIST_PR_KEY" ON "VNXX_DELIVERY_RDC_HIST_IF" ("PICK_NO", "LINE_ID", "DELIVERY_QTY", "DELIVERY_DATE", "PLAN_NO", "MODEL", "SUFFIX", "SHIPTO_CODE") 
  ;
--------------------------------------------------------
--  DDL for Index PK_VNXX_EDI_RESULT_PR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_VNXX_EDI_RESULT_PR" ON "VNXX_EDI_RESULT" ("EDI_DATE", "EDI_TYPE") 
  ;
--------------------------------------------------------
--  DDL for Index VNXX_ORDER_SHIP_HIST_PR_KEY
--------------------------------------------------------

  CREATE UNIQUE INDEX "VNXX_ORDER_SHIP_HIST_PR_KEY" ON "VNXX_ORDER_SHIP_HIST_IF" ("ORDER_NO", "MODEL", "SUFFIX", "SHIPTO_CODE", "ORDER_QTY", "INV_ORG") 
  ;
--------------------------------------------------------
--  DDL for Index VNXX_ORDER_NO_IDX
--------------------------------------------------------

  CREATE INDEX "VNXX_ORDER_NO_IDX" ON "VNXX_ORDER_SHIP_HIST_IF" ("ORDER_NO") 
  ;
--------------------------------------------------------
--  DDL for Index PK_VNXXSHPCFM_PR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_VNXXSHPCFM_PR" ON "VNXX_SHPCFM_IF" ("INTERFACE_ID") 
  ;
--------------------------------------------------------
--  DDL for Index PK_VNXX_SERIAL_PR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_VNXX_SERIAL_PR" ON "VNXX_SHPSERIAL_IF" ("SERIAL_TRANSACTION_ID") 
  ;
--------------------------------------------------------
--  DDL for Index VNXX_SN_RDC_HIST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "VNXX_SN_RDC_HIST_PK" ON "VNXX_SN_RDC_HIST_IF" ("INV_ORG", "SERIAL_NO", "MODEL", "SUFFIX", "OUT_DATE") 
  ;
--------------------------------------------------------
--  DDL for Index PK_XVH_ORDER_SHIP_HIST_PR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_XVH_ORDER_SHIP_HIST_PR" ON "VXH_ORDER_SHIP_HIST" ("INV_ORG", "SHIPTO_CODE", "ORDER_NO", "LINE_NO", "ORDER_QTY", "RELEASE_QTY", "MODEL", "SUFFIX") 
  ;
--------------------------------------------------------
--  DDL for Index XVH_SN__RDC_HIST_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "XVH_SN__RDC_HIST_PK" ON "XVH_SN_RDC_HIST" ("SERIAL_NO", "EDI_NO", "INV_ORG", "MODEL", "SUFFIX") 
  ;
--------------------------------------------------------
--  DDL for Index PR_XX_TEMP
--------------------------------------------------------

  CREATE UNIQUE INDEX "PR_XX_TEMP" ON "XX_TEMP" ("LOT_BOX")  
--------------------------------------------------------